go
CREATE PROCEDURE [DBO].[ConsultarHorasPractica](@idPractica INT)
AS
Begin
SET NOCOUNT ON;

Select h.diaSemana,h.horaInicio,h.horaFin, s.nombre,s.tipo from HorarioClase h, Practica p, Salon s where h.fk_SeccionPractica = p.id_Practica and p.id_Practica = @idPractica and s.id_salon = h.fk_Salon and p.statusPractica = 'Activo';

END